package com.kcs.fxmargin.service;

import java.sql.Connection;

import org.apache.log4j.Logger;

import com.kcs.common.utils.ConnectionUtils;
import com.kcs.common.utils.Constant;
import com.kcs.fxmargin.bo.ImportRRAndMMBO;
import com.kcs.fxmargin.dao.ImportRRAndMMDAO;

public class ImportRRAndMMService {
	private Logger log = Logger.getLogger(Constant.LOG_FX);
	
	public ImportRRAndMMBO getImportRRAndMMList(ImportRRAndMMBO bo)throws Exception{
		Connection conn = null;
		ImportRRAndMMDAO dao = null;
		
		log.info("Begin : ImportRRAndMMService : getImportRRAndMMList");
		
		try{
			
			conn = ConnectionUtils.getConnection(Constant.MSSQL, Constant.TO);
			dao = new ImportRRAndMMDAO();
			bo = dao.getImportRRAndMMList(bo, conn);
			
		}catch(Exception e){
			throw e;
		}finally{
			if(conn != null){
				try{
					conn.close();
				}catch(Exception ex){
					throw ex;
				}
			}
		}
		
		log.info("End : ImportRRAndMMService : getImportRRAndMMList");
		return bo;
		
	}

}
